Lesson: 15 - Sorting & Conditional formatting in Spreadsheets

Purpose: Students learn about freezing rows/columns, sorting and conditional formatting.

No. of. Classes

One hour - One class.

Materials Required

Desktop computer or Laptop & Open office.

Curriculum Content

7.5) Sorting, Conditional formatting.

Prior knowledge

Students should be comfortable with basic operations in spreadsheets.


Students should know about the usage of relational (<, <=, >, >=) operators.

Exercises

Exercise:1

1. How do you sort and freeze rows / columns in a spreadsheet?


Exercise:2

2. Students should create students' mark list in spreadsheet and find the lowest mark and change the cell colour into light red.


Exercise:3

3. Change the colour into light green of the cell which has the first rank in the above mark lis.


Use this excel file to teach, freeze some rows and columns.


Solutions


  • Link to view the Solution Video for Exercise-1 (Solution).
  • Link to view the Solution Video for Exercise-2 & 3 (Solution).

    • Instruction for Teachers
    1. Teachers should observe all the students' performance specially who makes mistakes.
    2. If they don't understand, explain to them and make them to do the exercises with others in the group.